# coding=utf-8
# 代码文件：chapter3/ch3.2.6.py
from datetime import date

import xlwings as xw

app = xw.App(visible=False, add_book=False)
f = r'data/学生信息.xlsx'

wb = app.books.open(f)

sheet1 = wb.sheets['Sheet1']

# 获取a1:f7区域
rng1 = sheet1.range('a1:f7')

# 为range对象设置参数
rng2 = rng1.options(numbers=int, dates=date, empty='NA')

L = rng2.value
print(" 打印二维数组L------------")
for x in L:
    print(x)

wb.close()
app.quit()

print('Game Over')
